SQL Server must be monitored to discover unauthorized changes to stored procedures.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-41406	SQL2-00-015200	SV-53933r1_rule		Medium

Description
When dealing with change control issues, it should be noted, any changes to the hardware, software, and/or firmware components of SQL Server and/or application can potentially have significant effects on the overall security of the system. If SQL Server were to allow any user to make changes to software libraries, then those changes might be implemented without undergoing the appropriate testing and approvals that are part of a robust change management process. This requirement is contingent upon the language in which the application is programmed, as many application architectures in use today incorporate their software libraries into, and make them inseparable from, their compiled distributions, rendering them static and version dependant. However, this requirement does apply to applications with software libraries accessible and configurable, as in the case of interpreted languages. Accordingly, only qualified and authorized individuals shall be allowed to obtain access to SQL Server components for purposes of initiating changes, including upgrades and modifications. Unmanaged changes that occur to the SQL Server software libraries or configuration, such as Stored Procedures, can lead to unauthorized or compromised installations.

Description

When dealing with change control issues, it should be noted, any changes to the hardware, software, and/or firmware components of SQL Server and/or application can potentially have significant effects on the overall security of the system. If SQL Server were to allow any user to make changes to software libraries, then those changes might be implemented without undergoing the appropriate testing and approvals that are part of a robust change management process. This requirement is contingent upon the language in which the application is programmed, as many application architectures in use today incorporate their software libraries into, and make them inseparable from, their compiled distributions, rendering them static and version dependant. However, this requirement does apply to applications with software libraries accessible and configurable, as in the case of interpreted languages. Accordingly, only qualified and authorized individuals shall be allowed to obtain access to SQL Server components for purposes of initiating changes, including upgrades and modifications. Unmanaged changes that occur to the SQL Server software libraries or configuration, such as Stored Procedures, can lead to unauthorized or compromised installations.

STIG	Date
Microsoft SQL Server 2012 Database Security Technical Implementation Guide	2014-06-23

Details

Check Text ( C-47943r2_chk )
Check the SQL Server configuration for the timed job that automatically checks all system and user-defined Stored Procedures for being modified by running the following SQL Server query: DECLARE @Job_title varchar(20) -- user-defined VARIABLE <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< SET @Job_title = '<'enter Stored Procedure modification job name'>' -- user-defined VARIABLE <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< EXEC sp_help_job @job_name = @Job_title GO If a timed job or some other method is not implemented to check for Stored Procedures being modified, this is a finding.

Check Text ( C-47943r2_chk )

Check the SQL Server configuration for the timed job that automatically checks all system and user-defined Stored Procedures for being modified by running the following SQL Server query:
DECLARE @Job_title varchar(20)
-- user-defined VARIABLE <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SET @Job_title = '<'enter Stored Procedure modification job name'>'
-- user-defined VARIABLE <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

EXEC sp_help_job
@job_name = @Job_title
GO

If a timed job or some other method is not implemented to check for Stored Procedures being modified, this is a finding.

Fix Text (F-46833r1_fix)
Configure a SQL Server timed job that automatically checks all system and user-defined Stored Procedures for modification.